Chat with Jentech AI on WhatsApp

Data Analytics Course Outline

A structured, hands-on curriculum designed to build data analytics skills week by week.

Course Goals

This enhanced 5-week curriculum is designed to transform students from "data curious" to "data fluent." In order to ensure learners develop the technical grit and attention to detail required to handle real-world, messy datasets before advancing to complex visual storytelling and executive reporting.

Week 1: Data Setup & Understanding

  • The Data Ecosystem
  • The "Data Cleaning" Phase
  • Practice & Assessment

Week 2: Data Analysis with Excel

  • Formulas & Logic
  • Pivot Tables & Data Summarization
  • Practice & Assessment

Week 3: SQL for Data Queries

  • Introduction to SQL
  • Filtering & Aggregation
  • Practice & Assessment

Week 4: Visualization & Communication

  • Principles of Visualization
  • Building Interactive Dashboards
  • Insight Communication

Week 5: Mini Project

  • End-to-End Processing
  • Dashboard Build & Storyboarding
  • Final Presentation